SUPPORT / SAMPLES & SAS NOTES
Problem Note 42074: SAS Merchandise Data Integration returning error code when loading at higher levels of time
 |  |  |  |
This SAS note applies to customers who are running SAS® Merchandise Data Integration 6.1.3 M5 or a later maintenance release on an Oracle database.
Problem:
The SAS Merchandise Data Integration application returns an error code when loading data at higher levels of the time hierarchy. Specifically, a non-zero return code appears in the log file at the end of the data load when the application is not able to locate the variable for a grandparent time level. The data is loaded properly in spite of the non-zero return code.
Resolution:
To resolve this issue, perform the following steps:
- Obtain the file named S0729708_update_1_13_2011.zip.
- Extract the mdi_create_time_vtree.sas file to the $MDI_ROOT/code/sascode directory (where $MDI_ROOT is the root directory for your installation).
Solution:
The solution is displayed in the following section of mdi_create_time_vtree.sas code:
%save_syscc /* todogander -no grandparent level when loading at season level, so masking syscc */
%if &parent_number>0 %then
%do;
%let parent_level =&&tnl&parent_number;
%let grandparent_number=&&tpn&parent_number;
%let grandparent_level =&&tnl&grandparent_number;
%end;
%else
%do;
%let parent_level =0;
%let grandparent_number=0;
%let grandparent_level =0;
%end;
%restore_saved_syscc /* todogander */
File S0729708_update_1_13_2011.zip may be downloaded here
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | 64-bit Enabled AIX | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| SAS System | SAS Merchandise Assortment Planning | Microsoft Windows Server 2003 Enterprise Edition | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| 64-bit Enabled AIX | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 6.1.3M5 | 6.4 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||